package com.scvtc.mapper.student;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.scvtc.domain.entity.student.StudentsBase;
import com.scvtc.domain.vo.student.base.StuEnrollmentPlanVo;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 学生基本信息(StudentsBase)表数据库访问层
 *
 * @author yiFei
 * @since 2022-04-13 17:38:27
 */
public interface StudentsBaseMapper extends BaseMapper<StudentsBase> {
    /**
     * 学生男女比例 (echarts 图)
     *
     * @return
     */
    @MapKey(value = "name")
    List<Map<String, Object>> chartGender();

    /**
     * 学生近三年招生(echarts 图)
     *
     * @return
     */
    List<StuEnrollmentPlanVo> chartEnrollmentPlan(@Param("year") Integer year);
}

